Records in the wrong order in query result due to not specified before running.
Cause:
The records are in the wrong order in a query result because the sort was not specified before running the query.
Solution:
Open the query, and either perform a simple sort Datasheet view or specify which fields to sort on in Design view.
Do the following to re-sort the query result:
1) If the Database window is not activated, activate the Database window.
2) Select the 'Queries' tab.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Open'. (The table appears in Datasheet view.)
5) Do one of the following:
a) To perform a simple sort on all the fields:
1] Select the 'Records' menu and select 'Sort'. (A submenu appears.)
2] Select 'Ascending' or 'Descending' to sort all the records in the query.
Sort records
b) To specify which fields to sort on:
1] Select the 'Records' menu and select 'Filter'. (A submenu appears.)
2] Select 'Advanced Filter/Sort...'. (The query appears in Design view.)
3] In the query design grid, click in the 'Sort' row for the desired field column to sort. (A drop-down arrow appears.)
Design grid
4] Click on the arrow. (A drop-down list appears.)
5] Select the desired sort order from the 'Sort' drop-down list.
6] Repeat steps 5)b)3] through 5)b)5] for each field to use for the sort.
7] Select the 'Filter' menu and select 'Apply Filter/Sort'. (The query reappears in Datasheet view.)
